OpenBots Command group containing data manipulation commands (Data, DataTable, Dictionary, List, RegEx).
OpenBots.Commands.DataManipulation \ Lookup Data Table Command
This command searches for a value inside a DataTable and returns the DataRow containing the cell. If the target column is set, it also returns the value of the cell from the specified DataRow.
DataTable
Enter an existing DataTable to lookup from.
Required
Lookup Value
Enter the value to search for in the specified DataTable.
Required
Search Option (Lookup Column)
Select whether the Lookup Column should be found by column index or column name.
Required
Search Value (Lookup Column)
Enter a valid DataColumn index or column name.
Required
Search Option (Target Column)
Select whether the Target Column should be found by column index or column name.
Required
Search Value (Target Column)
Enter a valid DataColumn index or column name.
Output DataRow Variable
Create a new variable or select a variable from the list.
Output Cell Value Variable
Create a new variable or select a variable from the list.
Private (Optional)
Optional field to mark the command as private (data sensitive) in order to avoid its logging.
Error Handling
Optional field for how to handle errors encountered.
Required
Comment Field (Optional)
Optional field to enter a custom comment which could potentially describe this command or the need for this command.